Fall 2020 Course Syllabus Course: POFI-1349- Section: 71 Spreadsheets

Instructor Information
Instructor	Adriane Champagne
E-mail	champagneam@lamarpa.edu
Phone	(409) 984-6416
Office	Location: Madison Monroe Education - Room: 207 Hours: Tuesday 9:00 a.m.-2:00 p.m.; Wednesday 11:00 a.m.- 3:00 p.m.; Friday 11:00 a.m.-12:00 p.m. Other office hours scheduled as needed by appointment.
Department	Business and Industrial Technology Chair: Sheila Guillot E-mail: guillsr@lamarpa.edu Phone: (409) 984-6381 If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair.
COVID 19 Information	The Lamar State College Port Arthur (LSCPA) Student Code of Conduct COVID 19 Policy requires students who have been exposed to COVID 19 or diagnosed with COVID 19 to report their condition on the COVID 19 Notification Form (available via a link on the Student Code of Conduct COVID19 webpage). This information will be provided to the Dean of Student Services. In addition, this policy requires all students to wear face coverings in compliance with the criteria included in the policy. For more information please refer to the COVID 19 link on the LSCPA website.
Course Information
Description	Skill development in concepts, procedures, and application of spreadsheets. This course is designed to be repeated multiple times to improve student proficiency.
Prerequisites	Basic Computer Skills.
Learning Outcomes	1. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading (PSLO ALPHA); measured by pre- and post-tests 2. Identifies terminology and concepts associated with spreadsheet applications (PSLO 1 & 2); measured by daily assignment 3. Insert graphics, generate charts and reports in worksheets (PSLO 3); measured by daily assignment 4. Create and modify workbooks (PSLO 3); measured by end-of-chapter assessment assignment 5. Create and use special functions (PSLO 3); measured by end-of-chapter assessment assignment 6. Calculate data using formulas and functions (PSLO 3); measured by daily assignment 7. Proofread and edit workbooks (PSLO 4); measured by application assignment
Core Objectives
Program Student Learning Outcomes	PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material. PSLO 1. Demonstrates appropriate professionalism in the administrative workplace environment. SLO 1. Students will demonstrate appropriate professionalism in the administrative workplace environment PSLO 2. Uses current business administration skills. SLO 2. Students will use current business administration skills. PSLO 3. Uses current business office software applications. SLO 3. Students will use current business office software applications. PSLO 4. Proofreads and edits business documents. SLO 4. Students will proofread and edit business documents.
Textbooks	Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer. ISBN: 9781305880412 Parsons New Perspectives Microsoft Office 365 Excel 2016 Cengage Learning 2017 BOOK REQUIRED no access code. Access to a computer with Microsoft Excel 2016 or 2019 required.
Lecture Topics Outline	Week Topic 09/08/2020 Introduction to Course-Syllabus review, pre-test, Blackboard and Self Service Banner 09/08/2020 Managing Your Files- Will need 8 GB flash drive and book. Excel Module 1: Getting Started-Excel 09/15/2020 Excel Module 2: Formatting Workbook Text and Data (Session 2.1) 09/21/2020 Excel Module 2: Formatting Workbook Text and Data (Session 2.2) 09/29/2020 Excel Module 3: Calculating Data with Formulas and Functions (Session 3.1) 10/06/2020 Excel Module 3: Calculating Data with Formulas and Functions (Session 3.2) 10/13/2020 Mid-term Exam #1 10/13/2020 Excel Module 4: Analyzing and Charting Financial Data (Session 4.1) 11/03/2020 Excel Module 4: Analyzing and Charting Financial Data (Session 4.2) 11/10/2020 Excel Module 5: Working with Excel Tables, PivotTables, and PivotCharts (Session 5.1 & 5.2) 11/17/2020 Excel Module 5: Working with Excel Tables, PivotTables, and PivotCharts (Session 5.2 & 5.3) 11/26/2020 Excel Module 6: Managing Multiple Worksheets and Workbooks (Session 6.1 & 6.2) 12/03/2020 Final Exam #2 12/11/2020 Fall Commencement -5:30 p.m. Schedule subject to change
Major Assignments Schedule	This course syllabus is for an ONLINE section for the Fall 2020 semester. The instructor reserves the right to drop any student missing more than two weeks with no online class or lab participation. "Attendance" is monitored as participation and logging into the course. Assignments are due on the dates provided in Blackboard. Students are responsible for completing all assigned homework, including reading assignments, by the required due dates. Week    Topic 1    Pre-test, Introduction Discussion Board post 1    Submission of Online learning survey Excel Module 1: Creating a Customer Order Report (Game Card) 2    Excel Module 2.1 Creating a Sales Report (Morning Bean) 3    Excel Module 2.2 Sales Report continued. 4    Excel Module 3.1 Calculating Farm Yield and Revenue 5    Excel Module 3.2 continued 6 Mid term Exam 1 6    Excel Module 4.1 Preparing a Business Plan 7    Excel Module 4.2 continued 8    Excel Module 5.1 Tracking Sales Data 9    Excel Module 5.2 and 5.3 continued 10 Excel Module 6.1 Summarizing Rental Income Data 10    Excel Module 6.2 and 6.3 continued 11    Exam #2 or MOS certification exam Schedule subject to change
Final Exam Date	December 4, 2020 - 10:00 AM   Through  December 6, 2020 - 8:00 PM
Grading Scale	90 - 100=A    80 - 89=B    70 - 79=C     60 - 69=D    Below 59 = F
Determination of Final Grade	Assignments/ Quizzes 60%, Exams 40%
Course Policies
Instructor Policies	Instructor Policies Homework assignments will be given each week. LATE WORK is highly discouraged and will incur a 25 point penalty for every day it is late. Due dates are given and enough time is given to complete all work. NO EXCEPTIONS. Academic Policies: Student IDs are required for the first exam. IDs must be visible on your desk before the exam is administered no ID, no exam. If you miss an exam, your lowest test grade will count twice. If you miss more than one exam, those exams will be given a grade of zero. Students must leave the classroom after exam is finished. There will be a final exam. All students must take the exam on the scheduled date and time, and failure to do so will result in a 0 on the final exam. Every student MUST have a copy of the required textbooks by the second week of class. The student will still be responsible for any assignments given. Failure to have a text may result in being dropped from the class. No emailed work is accepted. Students are responsible for completing all assigned reading and video viewings. A failure to follow oral and/or written instructions will result in penalties. Academic dishonesty will result in a zero on any assignment; a second incidence of academic dishonesty will be handled based on campus policies and procedures with the department chair. Students should keep a record of their grades/average. Instructor(s) will not average grades for students. Instructors do not drop grades. Quizzes will be given online and students are required to complete by due date. Assignments are due by 11:30 p.m. the night of the due date posted online. Students are responsible for completing all assigned homework and for being prepared for each class meeting including virtual meetings scheduled. This applies even if you were absent for the previous class meeting. Software Requirements: If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library. Reliable Internet access is required for all online courses and many traditional courses. Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. DO NOT wait until the last minute to complete class work or exams.
Attendance Policy	Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily online. In addition, attendance on a regular basis is necessary for proper skill development. Students are required to log onto the Blackboard online course multiple times a week.
Academic Honesty	Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty.
Facility Policies	No food or tobacco products are allowed in the classroom. Only students enrolled in the course are allowed in the classroom, except by special instructor permission. Use of electronic devices is prohibited.
Important Information
ADA Considerations	The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.
MyLSCPA	Be sure to check your campus E-mail and Course Homepage using MyLSCPA campus web portal (My.LamarPA.edu). When you've logged in, click the email icon in the upper right-hand corner to check email, or click on the "My Courses" tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLSCPA.
Other	Classroom Etiquette: The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; leaving class early without informing the instructor; surfing the Internet during lecture; and displaying a rude or negative behavior toward the instructor or other students. E-Mail/Voice Mail Etiquette: Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name/course name. Voice mail messages should be clearly spoken identifying students name, course, and any return phone number.
HB 2504	This syllabus is part of LSC-PA's efforts to comply with Texas House Bill 2504.